UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wc+xvM8t4sE1tB9OmSClLhwJjSnjt+ioVvtV7Pd+s+o='
WHERE
key_id = '1b1a0bea62bee1f14d5b6a979c994df9e7f697b2becc2e712a941565feb63989'
AND (
token = 'wc+xvM8t4sE1tB9OmSClLhwJjSnjt+ioVvtV7Pd+s+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)