UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '818p9E4miQatV2vfhvWnkhQx0k5ONmSbuaubjTo8zy8='
WHERE
key_id = 'c73b4b30dc5c9e78e0347df7443faddcc6c845399f7b8f06ca8fb98d3956fd9e'
AND (
token = '818p9E4miQatV2vfhvWnkhQx0k5ONmSbuaubjTo8zy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)