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