UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8WZ/YAFRZKAVXfuqvVUgi7JIGU/p8Avhb6gzNzSnct4='
WHERE
key_id = 'a1345c08f00d0ee541fa62581549afa4ca01c1c5beb1ec82adcc7654b75b046d'
AND (
token = '8WZ/YAFRZKAVXfuqvVUgi7JIGU/p8Avhb6gzNzSnct4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)