UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lQBNDkJ51j0Boj1mzWkZ2DsziNRCYpCO2M//OUfus7g='
WHERE
key_id = 'e6a879c7df06c6497d900778216cb888daffffa37223db041aa682d33fc82b01'
AND (
token = 'lQBNDkJ51j0Boj1mzWkZ2DsziNRCYpCO2M//OUfus7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)