UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7+G8exeJZIJcUWezCUkYuzILS460v9dY3NPwWV5WIcE='
WHERE
key_id = 'ded389b49ac55b31fe422f76ebfd64fc3f03627f3029224882763d9dc83cdf82'
AND (
token = '7+G8exeJZIJcUWezCUkYuzILS460v9dY3NPwWV5WIcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)