UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zOTTGgk1R4C8+RyuXMQjiXCXyqurrb3oUaQqxMXdPfo='
WHERE
key_id = 'a24651a534c3e19ec69624e3e95f2d8fa0c8ede31082bf66ec747f4ae312b7e2'
AND (
token = 'zOTTGgk1R4C8+RyuXMQjiXCXyqurrb3oUaQqxMXdPfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)