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