UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lh7py8BlXG3ARSXTzGxL+1LYzqW21UUeVURvW8HIT/c='
WHERE
key_id = 'c66465e3cf47a5f1d510b7ca908a6d9592c1823a88e7a7c52e40d4a92f2de22a'
AND (
token = 'lh7py8BlXG3ARSXTzGxL+1LYzqW21UUeVURvW8HIT/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)