UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jotZ0nCE7/P1LG9HeZoZwD4MFDTWHftFI+hRMm/xATM='
WHERE
key_id = 'bc35db886a47b2fc11fd1e39df9e4a9b5ce6f005dd19638e83847e9c650e7675'
AND (
token = 'jotZ0nCE7/P1LG9HeZoZwD4MFDTWHftFI+hRMm/xATM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)