UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3qZbHpyWo+rhhj483XZ3N83FToBIuRt6+zsFgLZ+Djo='
WHERE
key_id = 'd27a22f1ddea482b6f85c8d334997360f13b172c87e1cc0a3783a27c320bd76f'
AND (
token = '3qZbHpyWo+rhhj483XZ3N83FToBIuRt6+zsFgLZ+Djo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)