UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fh4kXX1v8JNQ7Zq3MNzncIDmuYe0TWYatORgTM9euAc='
WHERE
key_id = '0e135104c56b6c2a26f8cb2ab332d28e68c26a883ffe62e55fb0326df37f2f03'
AND (
token = 'fh4kXX1v8JNQ7Zq3MNzncIDmuYe0TWYatORgTM9euAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)