UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oaRZV/36Gpq2AvYchBYSvoCoVdduksxDnGSh8vQzFe4='
WHERE
key_id = '2f327244709a7157ae4cf68ea056ea060254b478236bc0b4539eb53cc1121a6d'
AND (
token = 'oaRZV/36Gpq2AvYchBYSvoCoVdduksxDnGSh8vQzFe4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)