UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9KtndCKxe3iiPKzroE/52HWCTWXDXGfQSYNzH9Qn7yU='
WHERE
key_id = '3cbafbe1df12515cb309bd9d63179984f67b2ed1e9da610ea547900e9c27323f'
AND (
token = '9KtndCKxe3iiPKzroE/52HWCTWXDXGfQSYNzH9Qn7yU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)