UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ieheufLu+CspAKEgm5AS6zthYNxGlm8klk1gDbgRh2E='
WHERE
key_id = '527e3d1367bddcef7b01188ad272c49c131a7428eea0adcc4962a94bb5be8227'
AND (
token = 'ieheufLu+CspAKEgm5AS6zthYNxGlm8klk1gDbgRh2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)