UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j8070Ii43oVKle67pB+qMpYi4/AAx0utupkeiEsoyBo='
WHERE
key_id = 'abd7d8b65fc870aaf4bca6bd25ba9357350e21df5358ede42cd1c92f7a9bda30'
AND (
token = 'j8070Ii43oVKle67pB+qMpYi4/AAx0utupkeiEsoyBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)