UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '32/xIereyvtkeJ5hTR7ZevBFbjvnrRIdaIB2JH1h9/c='
WHERE
key_id = '8a531fd4aaec8299491b712de7e138c5ff2a26314a10369dde5f590051580f6f'
AND (
token = '32/xIereyvtkeJ5hTR7ZevBFbjvnrRIdaIB2JH1h9/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)