UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnKn8rFkmFLoJYMHurQ+7bOSa0lz8Zn0bXhfj+33xeU='
WHERE
key_id = 'bd9a3de2ef4b5c66d1114c3d4549d8361178097def969a208c3c62f2e029ef0b'
AND (
token = 'ZnKn8rFkmFLoJYMHurQ+7bOSa0lz8Zn0bXhfj+33xeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)