UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TgByLltF9HC5FsDGvE1npmBZBRWHenx12voBnoLwv84='
WHERE
key_id = '8f9753e01831a00a723ea47cab29abe4a2390da4b843b272b5d3f10b6c034e9f'
AND (
token = 'TgByLltF9HC5FsDGvE1npmBZBRWHenx12voBnoLwv84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)