UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yIW5hcB5042FkgKXu6oKntuIpk6Z5So8Lb/xIG/9qgQ='
WHERE
key_id = 'e6470a8e1ed91f8f3f143b58b2443b4102b803624f441b0d70e64ec5759988dc'
AND (
token = 'yIW5hcB5042FkgKXu6oKntuIpk6Z5So8Lb/xIG/9qgQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)