UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '84R3bG0XQvDjf5BSiYoKNpWF9szlYDKWQC/1aCxWcik='
WHERE
key_id = '93b4a74197133a1b30a13a3dd9c4b42fd9c8e0d12dde5ef0f178b7f097411593'
AND (
token = '84R3bG0XQvDjf5BSiYoKNpWF9szlYDKWQC/1aCxWcik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)