UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qPn15Tgb86YniBRPwXmn/BQWq9lccRSLbcppZDoUYeY='
WHERE
key_id = '6d24ab9f5472ae2ba14b004a464b1dc4e10ffc316989b8bfc38cb4b16c6fb094'
AND (
token = 'qPn15Tgb86YniBRPwXmn/BQWq9lccRSLbcppZDoUYeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)