UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YQTVBgxAzUFCzD3hhydrVOhJRRL5RU6XYzs6PMooI8w='
WHERE
key_id = '2e83d2c104a519927204dfe129820a173e22447465ac7ce8bcf6043505951391'
AND (
token = 'YQTVBgxAzUFCzD3hhydrVOhJRRL5RU6XYzs6PMooI8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)