UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZdZ7hDtUMBVX9kkNT8G62ehWnHRDBfM4dVZY7dnbKg='
WHERE
key_id = 'd098115703724baaedb805b4a15ce3ca296d80f29440a452e58dd425d55bb7bc'
AND (
token = 'hZdZ7hDtUMBVX9kkNT8G62ehWnHRDBfM4dVZY7dnbKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)