UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4B4zOHmctfhl1o5eQG6yX+9sZACCSXsecMTQ+k2JoK4='
WHERE
key_id = '0a572ca47f6dc1b8790756612d145f4afa800c996ea84bc6b8812f506f7285b7'
AND (
token = '4B4zOHmctfhl1o5eQG6yX+9sZACCSXsecMTQ+k2JoK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)