UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3YMVY1uGY3CLWYCG29th7dC5W/Jkr+yeYZRpidCnLsw='
WHERE
key_id = 'aa716b3a7bb2c8257802de16ed230d78716dbb2e19a3d0956a75b6b26658b24b'
AND (
token = '3YMVY1uGY3CLWYCG29th7dC5W/Jkr+yeYZRpidCnLsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)