UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AUgsD5yCiUIBNe0GbUKGafjPzXT4R2mZ5qL9NvGYKkM='
WHERE
key_id = 'bc3e30307eacd77b681039f1f49ae4cce0fa07698eed3f500d51c48845199cd2'
AND (
token = 'AUgsD5yCiUIBNe0GbUKGafjPzXT4R2mZ5qL9NvGYKkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)