UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2NO1+tDNe7ImHNSO4WS35565flOItEo6y9wOIDa3qQg='
WHERE
key_id = 'b7b8ed25c8bc3d5a92ef6876405866120ee6257bd033407d8d9742cd9ff906ef'
AND (
token = '2NO1+tDNe7ImHNSO4WS35565flOItEo6y9wOIDa3qQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)