UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XxN8AhqeWT5UV+T1d8gkmJDKSZdukd5436O6H+3EdVs='
WHERE
key_id = '47a8c692d95d8e948aa58c0d91f10b904d9fbe2d49c6a0967abc7db307460317'
AND (
token = 'XxN8AhqeWT5UV+T1d8gkmJDKSZdukd5436O6H+3EdVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)