UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6nbvuHQWLFX3p9/m+FK7xeXw3BMOJayDspduVkBjFX0='
WHERE
key_id = 'f80ddc9150bde32f823b56e1109ef4904687a3878a243aae5a0eeec7dc3f2303'
AND (
token = '6nbvuHQWLFX3p9/m+FK7xeXw3BMOJayDspduVkBjFX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)