UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v94TxW+31+f0PF2C2nj6UeskdfXGNNWWQMcPjPUn6WM='
WHERE
key_id = 'aff100d0de86716c13be02c038d327377d1e80be9a13e12dd4fffecbc7a3b117'
AND (
token = 'v94TxW+31+f0PF2C2nj6UeskdfXGNNWWQMcPjPUn6WM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)