UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZPe2K/tNUkSnF9eJjT7JB13Gr4QK5RXy44nX74slhz8='
WHERE
key_id = '7aa57685fe79f1a03a65170d39e4a6d42b54b9123bbc786eb5030ed55bb4416b'
AND (
token = 'ZPe2K/tNUkSnF9eJjT7JB13Gr4QK5RXy44nX74slhz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)