UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LTZf4J+TTK5Qi0Bx2wJ2hM3hXNvh99ZREyJWlK3UCyI='
WHERE
key_id = '7a9cffa44bf759c3a940aeba8c7e8300436e924ba4d4a6fb6dc4f250df253b22'
AND (
token = 'LTZf4J+TTK5Qi0Bx2wJ2hM3hXNvh99ZREyJWlK3UCyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)