UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9vADu15X4+itTFWjNfMvLQbUuiP1cb1aVlP1ak2y3WU='
WHERE
key_id = '64aec03d29854cc690556f44d15ffe11689f1310afe6beadfc2e0681c3666a4f'
AND (
token = '9vADu15X4+itTFWjNfMvLQbUuiP1cb1aVlP1ak2y3WU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)