UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Mlz1AtTvJB1VPWslGtsfv9U1nbhtpJ6FHS4/eE2jbw='
WHERE
key_id = '4f1470acc467bf4d2c6b482d55c547482e57190da0ba33cb2a90409be1f03a2f'
AND (
token = '3Mlz1AtTvJB1VPWslGtsfv9U1nbhtpJ6FHS4/eE2jbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)