UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0mdmJxnkoXIWSDn9YK6loddjQilLMdAY4nvXJSciVOY='
WHERE
key_id = 'e07992a207121468997ce5bc2950f8b568d0ae7fb82ee6efd8d1baafc3e12291'
AND (
token = '0mdmJxnkoXIWSDn9YK6loddjQilLMdAY4nvXJSciVOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)